package com.itheima.dao;

import com.itheima.pojo.FileSort;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import tk.mybatis.mapper.common.Mapper;

/**
 * @author xuchangshuo
 * @date 2020/8/6 20:22
 */
public interface FileSortMapper extends Mapper<FileSort> {

    //根据项目名称和模块名称查询分类id
    @Select("select uid from t_file_sort where project_name=#{projectName} and sort_name=#{sortName}")
    String getUidByProjectNameAndSortName(@Param("projectName") String projectName, @Param("sortName") String sortName);
}
